﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="MinimalGoalDataSet" targetNamespace="http://tempuri.org/MinimalGoalDataSet.xsd" xmlns:mstns="http://tempuri.org/MinimalGoalDataSet.xsd" xmlns="http://tempuri.org/MinimalGoalDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ActivateYourGlutes_TestDbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ActivateYourGlutes_TestDbConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ActivateYourGlutes.Model.Tests.Integration.Properties.Settings.GlobalReference.Default.ActivateYourGlutes_TestDbConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AccountTableAdapter" GeneratorDataComponentClassName="AccountTableAdapter" Name="Account" UserDataComponentName="AccountTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ActivateYourGlutes_TestDbConnectionString (Settings)" DbObjectName="ActivateYourGlutes_TestDb.dbo.Account" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Account] WHERE (([AccountId] = @Original_AccountId) AND ([Username] = @Original_Username) AND ([DateOfBirth] = @Original_DateOfBirth) AND ([UnitOfLengthId] = @Original_UnitOfLengthId) AND ([UnitOfWeightId] = @Original_UnitOfWeightId) AND ((@IsNull_PrimaryKeyIndicator = 1 AND [PrimaryKeyIndicator] IS NULL) OR ([PrimaryKeyIndicator] = @Original_PrimaryKeyIndicator)) AND ((@IsNull_SecondaryKeyIndicator = 1 AND [SecondaryKeyIndicator] IS NULL) OR ([SecondaryKeyIndicator] = @Original_SecondaryKeyIndicator)) AND ([LocalDateFormat] = @Original_LocalDateFormat) AND ((@IsNull_PrimaryMeasurementTypeId = 1 AND [PrimaryMeasurementTypeId] IS NULL) OR ([PrimaryMeasurementTypeId] = @Original_PrimaryMeasurementTypeId)) AND ((@IsNull_SecondaryMeasurementTypeId = 1 AND [SecondaryMeasurementTypeId] IS NULL) OR ([SecondaryMeasurementTypeId] = @Original_SecondaryMeasurementTypeId)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateOfBirth" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UnitOfLengthId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfLengthId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UnitOfWeightId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfWeightId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrimaryKeyIndicator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryKeyIndicator" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PrimaryKeyIndicator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryKeyIndicator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SecondaryKeyIndicator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SecondaryKeyIndicator" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SecondaryKeyIndicator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SecondaryKeyIndicator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LocalDateFormat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LocalDateFormat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrimaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryMeasurementTypeId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PrimaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryMeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SecondaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SecondaryMeasurementTypeId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SecondaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SecondaryMeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Account] ([Username], [DateOfBirth], [UnitOfLengthId], [UnitOfWeightId], [PrimaryKeyIndicator], [SecondaryKeyIndicator], [LocalDateFormat], [PrimaryMeasurementTypeId], [SecondaryMeasurementTypeId]) VALUES (@Username, @DateOfBirth, @UnitOfLengthId, @UnitOfWeightId, @PrimaryKeyIndicator, @SecondaryKeyIndicator, @LocalDateFormat, @PrimaryMeasurementTypeId, @SecondaryMeasurementTypeId);
SELECT AccountId, Username, DateOfBirth, UnitOfLengthId, UnitOfWeightId, PrimaryKeyIndicator, SecondaryKeyIndicator, LocalDateFormat, PrimaryMeasurementTypeId, SecondaryMeasurementTypeId FROM Account WHERE (AccountId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateOfBirth" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UnitOfLengthId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfLengthId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UnitOfWeightId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfWeightId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PrimaryKeyIndicator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryKeyIndicator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SecondaryKeyIndicator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SecondaryKeyIndicator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LocalDateFormat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LocalDateFormat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PrimaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryMeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SecondaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SecondaryMeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT AccountId, Username, DateOfBirth, UnitOfLengthId, UnitOfWeightId, PrimaryKeyIndicator, SecondaryKeyIndicator, LocalDateFormat, PrimaryMeasurementTypeId, SecondaryMeasurementTypeId FROM dbo.Account</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Account] SET [Username] = @Username, [DateOfBirth] = @DateOfBirth, [UnitOfLengthId] = @UnitOfLengthId, [UnitOfWeightId] = @UnitOfWeightId, [PrimaryKeyIndicator] = @PrimaryKeyIndicator, [SecondaryKeyIndicator] = @SecondaryKeyIndicator, [LocalDateFormat] = @LocalDateFormat, [PrimaryMeasurementTypeId] = @PrimaryMeasurementTypeId, [SecondaryMeasurementTypeId] = @SecondaryMeasurementTypeId WHERE (([AccountId] = @Original_AccountId) AND ([Username] = @Original_Username) AND ([DateOfBirth] = @Original_DateOfBirth) AND ([UnitOfLengthId] = @Original_UnitOfLengthId) AND ([UnitOfWeightId] = @Original_UnitOfWeightId) AND ((@IsNull_PrimaryKeyIndicator = 1 AND [PrimaryKeyIndicator] IS NULL) OR ([PrimaryKeyIndicator] = @Original_PrimaryKeyIndicator)) AND ((@IsNull_SecondaryKeyIndicator = 1 AND [SecondaryKeyIndicator] IS NULL) OR ([SecondaryKeyIndicator] = @Original_SecondaryKeyIndicator)) AND ([LocalDateFormat] = @Original_LocalDateFormat) AND ((@IsNull_PrimaryMeasurementTypeId = 1 AND [PrimaryMeasurementTypeId] IS NULL) OR ([PrimaryMeasurementTypeId] = @Original_PrimaryMeasurementTypeId)) AND ((@IsNull_SecondaryMeasurementTypeId = 1 AND [SecondaryMeasurementTypeId] IS NULL) OR ([SecondaryMeasurementTypeId] = @Original_SecondaryMeasurementTypeId)));
SELECT AccountId, Username, DateOfBirth, UnitOfLengthId, UnitOfWeightId, PrimaryKeyIndicator, SecondaryKeyIndicator, LocalDateFormat, PrimaryMeasurementTypeId, SecondaryMeasurementTypeId FROM Account WHERE (AccountId = @AccountId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateOfBirth" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UnitOfLengthId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfLengthId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UnitOfWeightId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfWeightId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PrimaryKeyIndicator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryKeyIndicator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SecondaryKeyIndicator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SecondaryKeyIndicator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LocalDateFormat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LocalDateFormat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PrimaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryMeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SecondaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SecondaryMeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateOfBirth" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UnitOfLengthId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfLengthId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UnitOfWeightId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfWeightId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrimaryKeyIndicator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryKeyIndicator" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PrimaryKeyIndicator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryKeyIndicator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SecondaryKeyIndicator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SecondaryKeyIndicator" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SecondaryKeyIndicator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SecondaryKeyIndicator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LocalDateFormat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LocalDateFormat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrimaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryMeasurementTypeId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PrimaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryMeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SecondaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SecondaryMeasurementTypeId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SecondaryMeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SecondaryMeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="AccountId" ColumnName="AccountId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AccountId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AccountId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AccountId" DataSetColumn="AccountId" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="DateOfBirth" DataSetColumn="DateOfBirth" />
              <Mapping SourceColumn="UnitOfLengthId" DataSetColumn="UnitOfLengthId" />
              <Mapping SourceColumn="UnitOfWeightId" DataSetColumn="UnitOfWeightId" />
              <Mapping SourceColumn="PrimaryKeyIndicator" DataSetColumn="PrimaryKeyIndicator" />
              <Mapping SourceColumn="SecondaryKeyIndicator" DataSetColumn="SecondaryKeyIndicator" />
              <Mapping SourceColumn="LocalDateFormat" DataSetColumn="LocalDateFormat" />
              <Mapping SourceColumn="PrimaryMeasurementTypeId" DataSetColumn="PrimaryMeasurementTypeId" />
              <Mapping SourceColumn="SecondaryMeasurementTypeId" DataSetColumn="SecondaryMeasurementTypeId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GoalTableAdapter" GeneratorDataComponentClassName="GoalTableAdapter" Name="Goal" UserDataComponentName="GoalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ActivateYourGlutes_TestDbConnectionString (Settings)" DbObjectName="ActivateYourGlutes_TestDb.dbo.Goal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Goal] WHERE (([GoalId] = @Original_GoalId) AND ([AccountId] = @Original_AccountId) AND ([CreatedOn] = @Original_CreatedOn) AND ([TargetValue] = @Original_TargetValue) AND ((@IsNull_TargetDate = 1 AND [TargetDate] IS NULL) OR ([TargetDate] = @Original_TargetDate)) AND ([DecreaseTo] = @Original_DecreaseTo) AND ((@IsNull_AchievedOn = 1 AND [AchievedOn] IS NULL) OR ([AchievedOn] = @Original_AchievedOn)) AND ([Active] = @Original_Active) AND ([MeasurementTypeId] = @Original_MeasurementTypeId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GoalId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GoalId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedOn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TargetValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TargetValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TargetDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TargetDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TargetDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TargetDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DecreaseTo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DecreaseTo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AchievedOn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AchievedOn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_AchievedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AchievedOn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Active" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Active" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Goal] ([AccountId], [CreatedOn], [TargetValue], [TargetDate], [DecreaseTo], [AchievedOn], [Active], [MeasurementTypeId]) VALUES (@AccountId, @CreatedOn, @TargetValue, @TargetDate, @DecreaseTo, @AchievedOn, @Active, @MeasurementTypeId);
SELECT GoalId, AccountId, CreatedOn, TargetValue, TargetDate, DecreaseTo, AchievedOn, Active, MeasurementTypeId FROM Goal WHERE (GoalId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedOn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TargetValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TargetValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TargetDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TargetDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DecreaseTo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DecreaseTo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AchievedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AchievedOn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Active" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Active" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT GoalId, AccountId, CreatedOn, TargetValue, TargetDate, DecreaseTo, AchievedOn, Active, MeasurementTypeId FROM dbo.Goal</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Goal] SET [AccountId] = @AccountId, [CreatedOn] = @CreatedOn, [TargetValue] = @TargetValue, [TargetDate] = @TargetDate, [DecreaseTo] = @DecreaseTo, [AchievedOn] = @AchievedOn, [Active] = @Active, [MeasurementTypeId] = @MeasurementTypeId WHERE (([GoalId] = @Original_GoalId) AND ([AccountId] = @Original_AccountId) AND ([CreatedOn] = @Original_CreatedOn) AND ([TargetValue] = @Original_TargetValue) AND ((@IsNull_TargetDate = 1 AND [TargetDate] IS NULL) OR ([TargetDate] = @Original_TargetDate)) AND ([DecreaseTo] = @Original_DecreaseTo) AND ((@IsNull_AchievedOn = 1 AND [AchievedOn] IS NULL) OR ([AchievedOn] = @Original_AchievedOn)) AND ([Active] = @Original_Active) AND ([MeasurementTypeId] = @Original_MeasurementTypeId));
SELECT GoalId, AccountId, CreatedOn, TargetValue, TargetDate, DecreaseTo, AchievedOn, Active, MeasurementTypeId FROM Goal WHERE (GoalId = @GoalId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedOn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TargetValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TargetValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TargetDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TargetDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DecreaseTo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DecreaseTo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AchievedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AchievedOn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Active" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Active" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GoalId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GoalId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedOn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TargetValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TargetValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TargetDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TargetDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TargetDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TargetDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DecreaseTo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DecreaseTo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AchievedOn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AchievedOn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_AchievedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AchievedOn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Active" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Active" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="GoalId" ColumnName="GoalId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GoalId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GoalId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="GoalId" DataSetColumn="GoalId" />
              <Mapping SourceColumn="AccountId" DataSetColumn="AccountId" />
              <Mapping SourceColumn="CreatedOn" DataSetColumn="CreatedOn" />
              <Mapping SourceColumn="TargetValue" DataSetColumn="TargetValue" />
              <Mapping SourceColumn="TargetDate" DataSetColumn="TargetDate" />
              <Mapping SourceColumn="DecreaseTo" DataSetColumn="DecreaseTo" />
              <Mapping SourceColumn="AchievedOn" DataSetColumn="AchievedOn" />
              <Mapping SourceColumn="Active" DataSetColumn="Active" />
              <Mapping SourceColumn="MeasurementTypeId" DataSetColumn="MeasurementTypeId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MeasurementTypeTableAdapter" GeneratorDataComponentClassName="MeasurementTypeTableAdapter" Name="MeasurementType" UserDataComponentName="MeasurementTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ActivateYourGlutes_TestDbConnectionString (Settings)" DbObjectName="ActivateYourGlutes_TestDb.dbo.MeasurementType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[MeasurementType] WHERE (([MeasurementTypeId] = @Original_MeasurementTypeId) AND ([Description] = @Original_Description) AND ([Type] = @Original_Type) AND ([DisplayOrder] = @Original_DisplayOrder) AND ((@IsNull_AccountId = 1 AND [AccountId] IS NULL) OR ([AccountId] = @Original_AccountId)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DisplayOrder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[MeasurementType] ([Description], [Type], [DisplayOrder], [AccountId]) VALUES (@Description, @Type, @DisplayOrder, @AccountId);
SELECT MeasurementTypeId, Description, Type, DisplayOrder, AccountId FROM MeasurementType WHERE (MeasurementTypeId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DisplayOrder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MeasurementTypeId, Description, Type, DisplayOrder, AccountId FROM dbo.MeasurementType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[MeasurementType] SET [Description] = @Description, [Type] = @Type, [DisplayOrder] = @DisplayOrder, [AccountId] = @AccountId WHERE (([MeasurementTypeId] = @Original_MeasurementTypeId) AND ([Description] = @Original_Description) AND ([Type] = @Original_Type) AND ([DisplayOrder] = @Original_DisplayOrder) AND ((@IsNull_AccountId = 1 AND [AccountId] IS NULL) OR ([AccountId] = @Original_AccountId)));
SELECT MeasurementTypeId, Description, Type, DisplayOrder, AccountId FROM MeasurementType WHERE (MeasurementTypeId = @MeasurementTypeId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DisplayOrder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DisplayOrder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="MeasurementTypeId" ColumnName="MeasurementTypeId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@MeasurementTypeId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="MeasurementTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MeasurementTypeId" DataSetColumn="MeasurementTypeId" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="DisplayOrder" DataSetColumn="DisplayOrder" />
              <Mapping SourceColumn="AccountId" DataSetColumn="AccountId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UnitOfLengthTableAdapter" GeneratorDataComponentClassName="UnitOfLengthTableAdapter" Name="UnitOfLength" UserDataComponentName="UnitOfLengthTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ActivateYourGlutes_TestDbConnectionString (Settings)" DbObjectName="ActivateYourGlutes_TestDb.dbo.UnitOfLength" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[UnitOfLength] WHERE (([UnitOfLengthId] = @Original_UnitOfLengthId) AND ([Unit] = @Original_Unit) AND ([Description] = @Original_Description) AND ([ToMetersMultiplier] = @Original_ToMetersMultiplier))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UnitOfLengthId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfLengthId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ToMetersMultiplier" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ToMetersMultiplier" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[UnitOfLength] ([Unit], [Description], [ToMetersMultiplier]) VALUES (@Unit, @Description, @ToMetersMultiplier);
SELECT UnitOfLengthId, Unit, Description, ToMetersMultiplier FROM UnitOfLength WHERE (UnitOfLengthId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ToMetersMultiplier" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ToMetersMultiplier" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UnitOfLengthId, Unit, Description, ToMetersMultiplier FROM dbo.UnitOfLength</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[UnitOfLength] SET [Unit] = @Unit, [Description] = @Description, [ToMetersMultiplier] = @ToMetersMultiplier WHERE (([UnitOfLengthId] = @Original_UnitOfLengthId) AND ([Unit] = @Original_Unit) AND ([Description] = @Original_Description) AND ([ToMetersMultiplier] = @Original_ToMetersMultiplier));
SELECT UnitOfLengthId, Unit, Description, ToMetersMultiplier FROM UnitOfLength WHERE (UnitOfLengthId = @UnitOfLengthId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ToMetersMultiplier" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ToMetersMultiplier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UnitOfLengthId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfLengthId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ToMetersMultiplier" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ToMetersMultiplier" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UnitOfLengthId" ColumnName="UnitOfLengthId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UnitOfLengthId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UnitOfLengthId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UnitOfLengthId" DataSetColumn="UnitOfLengthId" />
              <Mapping SourceColumn="Unit" DataSetColumn="Unit" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="ToMetersMultiplier" DataSetColumn="ToMetersMultiplier" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UnitOfWeightTableAdapter" GeneratorDataComponentClassName="UnitOfWeightTableAdapter" Name="UnitOfWeight" UserDataComponentName="UnitOfWeightTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ActivateYourGlutes_TestDbConnectionString (Settings)" DbObjectName="ActivateYourGlutes_TestDb.dbo.UnitOfWeight" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[UnitOfWeight] WHERE (([UnitOfWeightId] = @Original_UnitOfWeightId) AND ([Unit] = @Original_Unit) AND ([Description] = @Original_Description) AND ([ToKgMultiplier] = @Original_ToKgMultiplier))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UnitOfWeightId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfWeightId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ToKgMultiplier" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ToKgMultiplier" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[UnitOfWeight] ([Unit], [Description], [ToKgMultiplier]) VALUES (@Unit, @Description, @ToKgMultiplier);
SELECT UnitOfWeightId, Unit, Description, ToKgMultiplier FROM UnitOfWeight WHERE (UnitOfWeightId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ToKgMultiplier" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ToKgMultiplier" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UnitOfWeightId, Unit, Description, ToKgMultiplier FROM dbo.UnitOfWeight</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[UnitOfWeight] SET [Unit] = @Unit, [Description] = @Description, [ToKgMultiplier] = @ToKgMultiplier WHERE (([UnitOfWeightId] = @Original_UnitOfWeightId) AND ([Unit] = @Original_Unit) AND ([Description] = @Original_Description) AND ([ToKgMultiplier] = @Original_ToKgMultiplier));
SELECT UnitOfWeightId, Unit, Description, ToKgMultiplier FROM UnitOfWeight WHERE (UnitOfWeightId = @UnitOfWeightId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ToKgMultiplier" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ToKgMultiplier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UnitOfWeightId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitOfWeightId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ToKgMultiplier" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ToKgMultiplier" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UnitOfWeightId" ColumnName="UnitOfWeightId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UnitOfWeightId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UnitOfWeightId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UnitOfWeightId" DataSetColumn="UnitOfWeightId" />
              <Mapping SourceColumn="Unit" DataSetColumn="Unit" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="ToKgMultiplier" DataSetColumn="ToKgMultiplier" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="MinimalGoalDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="MinimalGoalDataSet" msprop:Generator_DataSetName="MinimalGoalDataSet" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Account" msprop:Generator_UserTableName="Account" msprop:Generator_RowDeletedName="AccountRowDeleted" msprop:Generator_RowChangedName="AccountRowChanged" msprop:Generator_RowClassName="AccountRow" msprop:Generator_RowChangingName="AccountRowChanging" msprop:Generator_RowEvArgName="AccountRowChangeEvent" msprop:Generator_RowEvHandlerName="AccountRowChangeEventHandler" msprop:Generator_TableClassName="AccountDataTable" msprop:Generator_TableVarName="tableAccount" msprop:Generator_RowDeletingName="AccountRowDeleting" msprop:Generator_TablePropName="Account">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AccountId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="AccountId" msprop:Generator_ColumnVarNameInTable="columnAccountId" msprop:Generator_ColumnPropNameInRow="AccountId" msprop:Generator_ColumnPropNameInTable="AccountIdColumn" type="xs:int" />
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateOfBirth" msprop:Generator_UserColumnName="DateOfBirth" msprop:Generator_ColumnVarNameInTable="columnDateOfBirth" msprop:Generator_ColumnPropNameInRow="DateOfBirth" msprop:Generator_ColumnPropNameInTable="DateOfBirthColumn" type="xs:dateTime" />
              <xs:element name="UnitOfLengthId" msprop:Generator_UserColumnName="UnitOfLengthId" msprop:Generator_ColumnVarNameInTable="columnUnitOfLengthId" msprop:Generator_ColumnPropNameInRow="UnitOfLengthId" msprop:Generator_ColumnPropNameInTable="UnitOfLengthIdColumn" type="xs:int" />
              <xs:element name="UnitOfWeightId" msprop:Generator_UserColumnName="UnitOfWeightId" msprop:Generator_ColumnVarNameInTable="columnUnitOfWeightId" msprop:Generator_ColumnPropNameInRow="UnitOfWeightId" msprop:Generator_ColumnPropNameInTable="UnitOfWeightIdColumn" type="xs:int" />
              <xs:element name="PrimaryKeyIndicator" msprop:Generator_UserColumnName="PrimaryKeyIndicator" msprop:Generator_ColumnVarNameInTable="columnPrimaryKeyIndicator" msprop:Generator_ColumnPropNameInRow="PrimaryKeyIndicator" msprop:Generator_ColumnPropNameInTable="PrimaryKeyIndicatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SecondaryKeyIndicator" msprop:Generator_UserColumnName="SecondaryKeyIndicator" msprop:Generator_ColumnVarNameInTable="columnSecondaryKeyIndicator" msprop:Generator_ColumnPropNameInRow="SecondaryKeyIndicator" msprop:Generator_ColumnPropNameInTable="SecondaryKeyIndicatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LocalDateFormat" msprop:Generator_UserColumnName="LocalDateFormat" msprop:Generator_ColumnVarNameInTable="columnLocalDateFormat" msprop:Generator_ColumnPropNameInRow="LocalDateFormat" msprop:Generator_ColumnPropNameInTable="LocalDateFormatColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PrimaryMeasurementTypeId" msprop:Generator_UserColumnName="PrimaryMeasurementTypeId" msprop:Generator_ColumnVarNameInTable="columnPrimaryMeasurementTypeId" msprop:Generator_ColumnPropNameInRow="PrimaryMeasurementTypeId" msprop:Generator_ColumnPropNameInTable="PrimaryMeasurementTypeIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SecondaryMeasurementTypeId" msprop:Generator_UserColumnName="SecondaryMeasurementTypeId" msprop:Generator_ColumnVarNameInTable="columnSecondaryMeasurementTypeId" msprop:Generator_ColumnPropNameInRow="SecondaryMeasurementTypeId" msprop:Generator_ColumnPropNameInTable="SecondaryMeasurementTypeIdColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Goal" msprop:Generator_UserTableName="Goal" msprop:Generator_RowDeletedName="GoalRowDeleted" msprop:Generator_RowChangedName="GoalRowChanged" msprop:Generator_RowClassName="GoalRow" msprop:Generator_RowChangingName="GoalRowChanging" msprop:Generator_RowEvArgName="GoalRowChangeEvent" msprop:Generator_RowEvHandlerName="GoalRowChangeEventHandler" msprop:Generator_TableClassName="GoalDataTable" msprop:Generator_TableVarName="tableGoal" msprop:Generator_RowDeletingName="GoalRowDeleting" msprop:Generator_TablePropName="Goal">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="GoalId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="GoalId" msprop:Generator_ColumnVarNameInTable="columnGoalId" msprop:Generator_ColumnPropNameInRow="GoalId" msprop:Generator_ColumnPropNameInTable="GoalIdColumn" type="xs:int" />
              <xs:element name="AccountId" msprop:Generator_UserColumnName="AccountId" msprop:Generator_ColumnVarNameInTable="columnAccountId" msprop:Generator_ColumnPropNameInRow="AccountId" msprop:Generator_ColumnPropNameInTable="AccountIdColumn" type="xs:int" />
              <xs:element name="CreatedOn" msprop:Generator_UserColumnName="CreatedOn" msprop:Generator_ColumnVarNameInTable="columnCreatedOn" msprop:Generator_ColumnPropNameInRow="CreatedOn" msprop:Generator_ColumnPropNameInTable="CreatedOnColumn" type="xs:dateTime" />
              <xs:element name="TargetValue" msprop:Generator_UserColumnName="TargetValue" msprop:Generator_ColumnVarNameInTable="columnTargetValue" msprop:Generator_ColumnPropNameInRow="TargetValue" msprop:Generator_ColumnPropNameInTable="TargetValueColumn" type="xs:double" />
              <xs:element name="TargetDate" msprop:Generator_UserColumnName="TargetDate" msprop:Generator_ColumnVarNameInTable="columnTargetDate" msprop:Generator_ColumnPropNameInRow="TargetDate" msprop:Generator_ColumnPropNameInTable="TargetDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DecreaseTo" msprop:Generator_UserColumnName="DecreaseTo" msprop:Generator_ColumnVarNameInTable="columnDecreaseTo" msprop:Generator_ColumnPropNameInRow="DecreaseTo" msprop:Generator_ColumnPropNameInTable="DecreaseToColumn" type="xs:boolean" />
              <xs:element name="AchievedOn" msprop:Generator_UserColumnName="AchievedOn" msprop:Generator_ColumnVarNameInTable="columnAchievedOn" msprop:Generator_ColumnPropNameInRow="AchievedOn" msprop:Generator_ColumnPropNameInTable="AchievedOnColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Active" msprop:Generator_UserColumnName="Active" msprop:Generator_ColumnVarNameInTable="columnActive" msprop:Generator_ColumnPropNameInRow="Active" msprop:Generator_ColumnPropNameInTable="ActiveColumn" type="xs:boolean" />
              <xs:element name="MeasurementTypeId" msprop:Generator_UserColumnName="MeasurementTypeId" msprop:Generator_ColumnVarNameInTable="columnMeasurementTypeId" msprop:Generator_ColumnPropNameInRow="MeasurementTypeId" msprop:Generator_ColumnPropNameInTable="MeasurementTypeIdColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MeasurementType" msprop:Generator_UserTableName="MeasurementType" msprop:Generator_RowDeletedName="MeasurementTypeRowDeleted" msprop:Generator_RowChangedName="MeasurementTypeRowChanged" msprop:Generator_RowClassName="MeasurementTypeRow" msprop:Generator_RowChangingName="MeasurementTypeRowChanging" msprop:Generator_RowEvArgName="MeasurementTypeRowChangeEvent" msprop:Generator_RowEvHandlerName="MeasurementTypeRowChangeEventHandler" msprop:Generator_TableClassName="MeasurementTypeDataTable" msprop:Generator_TableVarName="tableMeasurementType" msprop:Generator_RowDeletingName="MeasurementTypeRowDeleting" msprop:Generator_TablePropName="MeasurementType">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MeasurementTypeId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="MeasurementTypeId" msprop:Generator_ColumnVarNameInTable="columnMeasurementTypeId" msprop:Generator_ColumnPropNameInRow="MeasurementTypeId" msprop:Generator_ColumnPropNameInTable="MeasurementTypeIdColumn" type="xs:int" />
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DisplayOrder" msprop:Generator_UserColumnName="DisplayOrder" msprop:Generator_ColumnVarNameInTable="columnDisplayOrder" msprop:Generator_ColumnPropNameInRow="DisplayOrder" msprop:Generator_ColumnPropNameInTable="DisplayOrderColumn" type="xs:int" />
              <xs:element name="AccountId" msprop:Generator_UserColumnName="AccountId" msprop:Generator_ColumnVarNameInTable="columnAccountId" msprop:Generator_ColumnPropNameInRow="AccountId" msprop:Generator_ColumnPropNameInTable="AccountIdColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UnitOfLength" msprop:Generator_UserTableName="UnitOfLength" msprop:Generator_RowDeletedName="UnitOfLengthRowDeleted" msprop:Generator_RowChangedName="UnitOfLengthRowChanged" msprop:Generator_RowClassName="UnitOfLengthRow" msprop:Generator_RowChangingName="UnitOfLengthRowChanging" msprop:Generator_RowEvArgName="UnitOfLengthRowChangeEvent" msprop:Generator_RowEvHandlerName="UnitOfLengthRowChangeEventHandler" msprop:Generator_TableClassName="UnitOfLengthDataTable" msprop:Generator_TableVarName="tableUnitOfLength" msprop:Generator_RowDeletingName="UnitOfLengthRowDeleting" msprop:Generator_TablePropName="UnitOfLength">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UnitOfLengthId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="UnitOfLengthId" msprop:Generator_ColumnVarNameInTable="columnUnitOfLengthId" msprop:Generator_ColumnPropNameInRow="UnitOfLengthId" msprop:Generator_ColumnPropNameInTable="UnitOfLengthIdColumn" type="xs:int" />
              <xs:element name="Unit" msprop:Generator_UserColumnName="Unit" msprop:Generator_ColumnVarNameInTable="columnUnit" msprop:Generator_ColumnPropNameInRow="Unit" msprop:Generator_ColumnPropNameInTable="UnitColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ToMetersMultiplier" msprop:Generator_UserColumnName="ToMetersMultiplier" msprop:Generator_ColumnVarNameInTable="columnToMetersMultiplier" msprop:Generator_ColumnPropNameInRow="ToMetersMultiplier" msprop:Generator_ColumnPropNameInTable="ToMetersMultiplierColumn" type="xs:double" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UnitOfWeight" msprop:Generator_UserTableName="UnitOfWeight" msprop:Generator_RowDeletedName="UnitOfWeightRowDeleted" msprop:Generator_RowChangedName="UnitOfWeightRowChanged" msprop:Generator_RowClassName="UnitOfWeightRow" msprop:Generator_RowChangingName="UnitOfWeightRowChanging" msprop:Generator_RowEvArgName="UnitOfWeightRowChangeEvent" msprop:Generator_RowEvHandlerName="UnitOfWeightRowChangeEventHandler" msprop:Generator_TableClassName="UnitOfWeightDataTable" msprop:Generator_TableVarName="tableUnitOfWeight" msprop:Generator_RowDeletingName="UnitOfWeightRowDeleting" msprop:Generator_TablePropName="UnitOfWeight">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UnitOfWeightId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="UnitOfWeightId" msprop:Generator_ColumnVarNameInTable="columnUnitOfWeightId" msprop:Generator_ColumnPropNameInRow="UnitOfWeightId" msprop:Generator_ColumnPropNameInTable="UnitOfWeightIdColumn" type="xs:int" />
              <xs:element name="Unit" msprop:Generator_UserColumnName="Unit" msprop:Generator_ColumnVarNameInTable="columnUnit" msprop:Generator_ColumnPropNameInRow="Unit" msprop:Generator_ColumnPropNameInTable="UnitColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ToKgMultiplier" msprop:Generator_UserColumnName="ToKgMultiplier" msprop:Generator_ColumnVarNameInTable="columnToKgMultiplier" msprop:Generator_ColumnPropNameInRow="ToKgMultiplier" msprop:Generator_ColumnPropNameInTable="ToKgMultiplierColumn" type="xs:double" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Account" />
      <xs:field xpath="mstns:AccountId" />
    </xs:unique>
    <xs:unique name="Goal_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Goal" />
      <xs:field xpath="mstns:GoalId" />
    </xs:unique>
    <xs:unique name="MeasurementType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MeasurementType" />
      <xs:field xpath="mstns:MeasurementTypeId" />
    </xs:unique>
    <xs:unique name="UnitOfLength_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UnitOfLength" />
      <xs:field xpath="mstns:UnitOfLengthId" />
    </xs:unique>
    <xs:unique name="UnitOfWeight_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UnitOfWeight" />
      <xs:field xpath="mstns:UnitOfWeightId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="fkGoalToAccount" msdata:parent="Account" msdata:child="Goal" msdata:parentkey="AccountId" msdata:childkey="AccountId" msprop:Generator_UserRelationName="fkGoalToAccount" msprop:Generator_RelationVarName="relationfkGoalToAccount" msprop:Generator_UserChildTable="Goal" msprop:Generator_UserParentTable="Account" msprop:Generator_ParentPropName="AccountRow" msprop:Generator_ChildPropName="GetGoalRows" />
      <msdata:Relationship name="fkPrimaryMeasurementType" msdata:parent="MeasurementType" msdata:child="Account" msdata:parentkey="MeasurementTypeId" msdata:childkey="PrimaryMeasurementTypeId" msprop:Generator_UserRelationName="fkPrimaryMeasurementType" msprop:Generator_RelationVarName="relationfkPrimaryMeasurementType" msprop:Generator_UserChildTable="Account" msprop:Generator_UserParentTable="MeasurementType" msprop:Generator_ParentPropName="MeasurementTypeRowByfkPrimaryMeasurementType" msprop:Generator_ChildPropName="GetAccountRowsByfkPrimaryMeasurementType" />
      <msdata:Relationship name="fkSecondaryMeasurementType" msdata:parent="MeasurementType" msdata:child="Account" msdata:parentkey="MeasurementTypeId" msdata:childkey="SecondaryMeasurementTypeId" msprop:Generator_UserRelationName="fkSecondaryMeasurementType" msprop:Generator_RelationVarName="relationfkSecondaryMeasurementType" msprop:Generator_UserChildTable="Account" msprop:Generator_UserParentTable="MeasurementType" msprop:Generator_ParentPropName="MeasurementTypeRowByfkSecondaryMeasurementType" msprop:Generator_ChildPropName="GetAccountRowsByfkSecondaryMeasurementType" />
      <msdata:Relationship name="fk_GoalMeasurementType" msdata:parent="MeasurementType" msdata:child="Goal" msdata:parentkey="MeasurementTypeId" msdata:childkey="MeasurementTypeId" msprop:Generator_UserRelationName="fk_GoalMeasurementType" msprop:Generator_RelationVarName="relationfk_GoalMeasurementType" msprop:Generator_UserChildTable="Goal" msprop:Generator_UserParentTable="MeasurementType" msprop:Generator_ParentPropName="MeasurementTypeRow" msprop:Generator_ChildPropName="GetGoalRows" />
      <msdata:Relationship name="fk_MeasurementTypeToAccount" msdata:parent="Account" msdata:child="MeasurementType" msdata:parentkey="AccountId" msdata:childkey="AccountId" msprop:Generator_UserRelationName="fk_MeasurementTypeToAccount" msprop:Generator_RelationVarName="relationfk_MeasurementTypeToAccount" msprop:Generator_UserChildTable="MeasurementType" msprop:Generator_UserParentTable="Account" msprop:Generator_ParentPropName="AccountRow" msprop:Generator_ChildPropName="GetMeasurementTypeRows" />
      <msdata:Relationship name="fkAccountToUnitOfLength" msdata:parent="UnitOfLength" msdata:child="Account" msdata:parentkey="UnitOfLengthId" msdata:childkey="UnitOfLengthId" msprop:Generator_UserRelationName="fkAccountToUnitOfLength" msprop:Generator_RelationVarName="relationfkAccountToUnitOfLength" msprop:Generator_UserChildTable="Account" msprop:Generator_UserParentTable="UnitOfLength" msprop:Generator_ParentPropName="UnitOfLengthRow" msprop:Generator_ChildPropName="GetAccountRows" />
      <msdata:Relationship name="fkAccountToUnitOfWeight" msdata:parent="UnitOfWeight" msdata:child="Account" msdata:parentkey="UnitOfWeightId" msdata:childkey="UnitOfWeightId" msprop:Generator_UserRelationName="fkAccountToUnitOfWeight" msprop:Generator_RelationVarName="relationfkAccountToUnitOfWeight" msprop:Generator_UserChildTable="Account" msprop:Generator_UserParentTable="UnitOfWeight" msprop:Generator_ParentPropName="UnitOfWeightRow" msprop:Generator_ChildPropName="GetAccountRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>